/*
 Navicat Premium Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : goods

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 28/08/2021 10:39:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for goodsinfo
-- ----------------------------
DROP TABLE IF EXISTS `goodsinfo`;
CREATE TABLE `goodsinfo` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `imgpath` varchar(255) DEFAULT NULL COMMENT '图片',
  `info` varchar(255) DEFAULT NULL COMMENT '介绍',
  `price` float(10,1) DEFAULT NULL COMMENT '价格',
  `shop` varchar(255) DEFAULT NULL COMMENT '店铺',
  `smallimg` varchar(255) DEFAULT NULL COMMENT '小图',
  `mainimg` varchar(255) NOT NULL COMMENT '主图',
  `jf` int DEFAULT NULL COMMENT '积分',
  PRIMARY KEY (`id`,`mainimg`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of goodsinfo
-- ----------------------------
BEGIN;
INSERT INTO `goodsinfo` VALUES (1, 'http://img.alicdn.com/bao/uploaded/i1/1105025069/O1CN0135HbQa1nJeMFYYNkX_!!1105025069.jpg_400x400Q50s50.jpg_.webp', '源氏木语实木餐桌简约橡木小户型饭桌北欧家用餐桌椅组合定制家具', 4848.0, '源氏木语家居旗舰店', 'http://img.alicdn.com/imgextra/i3/1105025069/O1CN01PLYorH1nJeLbdzzq1_!!0-item_pic.jpg_60x60q90.jpg', 'http://img.alicdn.com/imgextra/i3/1105025069/O1CN01PLYorH1nJeLbdzzq1_!!0-item_pic.jpg_430x430q90.jpg', 660);
INSERT INTO `goodsinfo` VALUES (2, 'http://img.alicdn.com/bao/uploaded/i1/143584903/O1CN01cXyWnr1m5cbuHsgmZ_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业北欧实木餐桌椅组合原木色橡木饭桌小户型岩板餐桌子BH2R', 1950.0, '林氏木业家具旗舰店', 'http://img.alicdn.com/imgextra/i1/1105025069/O1CN01VU0kbK1nJeI1m9NcW_!!1105025069.jpg_60x60q90.jpg', 'https://img.alicdn.com/imgextra/i1/1105025069/O1CN01VU0kbK1nJeI1m9NcW_!!1105025069.jpg_430x430q90.jpg', 224);
INSERT INTO `goodsinfo` VALUES (3, 'http://img.alicdn.com/bao/uploaded/i4/1105025069/O1CN01XQoCCQ1nJeMEK47CH_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '源氏木语纯实木沙发简约客厅休闲家具北欧小户型欧洲榉木家用沙发', 2460.0, '源氏木语家居旗舰店', 'http://img.alicdn.com/imgextra/i2/1105025069/O1CN01DqIF6S1nJeID67IIA_!!1105025069.jpg_60x60q90.jpg', 'https://img.alicdn.com/imgextra/i2/1105025069/O1CN01DqIF6S1nJeID67IIA_!!1105025069.jpg_430x430q90.jpg', 335);
INSERT INTO `goodsinfo` VALUES (4, 'http://img.alicdn.com/bao/uploaded/i1/143584903/O1CN01mae3YB1m5cbx5PmnT_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业北欧餐桌椅组合现代简约实木家用小户型饭桌子家具LS003', 2999.0, '林氏木业家具旗舰店', 'http://img.alicdn.com/imgextra/i2/1105025069/O1CN01meO5dv1nJeI83wkx7_!!1105025069.jpg_60x60q90.jpg', 'https://img.alicdn.com/imgextra/i2/1105025069/O1CN01meO5dv1nJeI83wkx7_!!1105025069.jpg_430x430q90.jpg', 244);
INSERT INTO `goodsinfo` VALUES (5, 'http://img.alicdn.com/bao/uploaded/i1/1105025069/O1CN01TCl3Xc1nJeMJVH2Z6_!!1105025069.jpg_400x400Q50s50.jpg_.webp', '源氏木语实木沙发组合现代简约休闲小户型客厅单人三人位布艺沙发', 4010.0, '源氏木语家居旗舰店', 'http://img.alicdn.com/imgextra/i1/1105025069/O1CN01t3E7TR1nJeIFsedMm_!!1105025069.jpg_60x60q90.jpg', 'https://img.alicdn.com/imgextra/i1/1105025069/O1CN01t3E7TR1nJeIFsedMm_!!1105025069.jpg_430x430q90.jpg', 566);
INSERT INTO `goodsinfo` VALUES (6, 'http://img.alicdn.com/bao/uploaded/i3/143584903/O1CN01JLsOWw1m5cbw6kS3f_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业北欧简约实木餐桌胡桃木色岩板餐桌椅组合长方形LS003R4', 3549.0, '林氏木业家具旗舰店', NULL, '', 543);
INSERT INTO `goodsinfo` VALUES (7, 'http://img.alicdn.com/bao/uploaded/i1/143584903/O1CN01lJj8F21m5cbv9W9DW_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业全实木餐桌简约橡木小户型饭桌原木色北欧餐桌椅组合CR2R', 4599.0, '林氏木业家具旗舰店', NULL, '', 676);
INSERT INTO `goodsinfo` VALUES (8, 'http://img.alicdn.com/bao/uploaded/i1/2207239419714/O1CN01haa5xC2Ld44trbFaT_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', 'IKEA宜家POANG波昂单人扶手椅休闲椅阳台休息椅子布艺欧式简约', 399.0, 'IKEA宜家家居官方旗舰店', NULL, '', 122);
INSERT INTO `goodsinfo` VALUES (9, 'http://img.alicdn.com/bao/uploaded/i2/2911805119/O1CN01wbq3Cm1ngYA0rRR19_!!2911805119.jpg_400x400Q50s50.jpg_.webp', '全友家私可伸缩餐桌北欧简约实木架餐桌椅组合钢化玻璃家具DW1001', 2240.0, '全友家私家具旗舰店', NULL, '', 342);
INSERT INTO `goodsinfo` VALUES (10, 'http://img.alicdn.com/bao/uploaded/i2/143584903/O1CN01WIdDaw1m5cc4uUQBC_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业岩板餐桌现代家用小户型餐桌椅组合岩板吃饭圆桌子LS003', 3950.0, '林氏木业家具旗舰店', NULL, '', 473);
INSERT INTO `goodsinfo` VALUES (11, 'http://img.alicdn.com/bao/uploaded/i4/1105025069/O1CN01QhnyAd1nJeLu9BwpY_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '源氏木语布艺蜗牛椅北欧单人沙发椅现代简约客厅摇椅懒人休闲椅', 2340.0, '源氏木语家居旗舰店', NULL, '', 345);
INSERT INTO `goodsinfo` VALUES (12, 'http://img.alicdn.com/bao/uploaded/i4/661916707/O1CN01ZWvOHA1zPr73helfg_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '顾家家居真皮沙发欧式现代轻奢客厅家具单人沙发休闲躺椅单椅A602', 3624.0, '顾家家居官方旗舰店', NULL, '', 678);
INSERT INTO `goodsinfo` VALUES (13, '//img.alicdn.com/bao/uploaded/i4/143584903/O1CN01t9zoCV1m5cbuHr0is_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业北欧岩板全实木餐桌椅吃饭原木色橡木小户型家用餐桌BH1R', 5250.0, '林氏木业家具旗舰店', NULL, '', 699);
INSERT INTO `goodsinfo` VALUES (14, '//img.alicdn.com/bao/uploaded/i1/2362249637/O1CN01SvjsCL2L3naI1fHaB_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '北欧餐桌家用小户型现代简约长方形桌子吃饭家用饭桌餐桌椅子组合', 378.0, '雅耐家居旗舰店', NULL, '', 102);
INSERT INTO `goodsinfo` VALUES (15, '//img.alicdn.com/bao/uploaded/i3/143584903/O1CN01pWFs6g1m5cc1JX24i_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '林氏木业北欧全实木餐桌椅组合简约原木色长方形玻钢石饭桌LS003', 3349.0, '林氏木业家具旗舰店', NULL, '', 340);
INSERT INTO `goodsinfo` VALUES (16, '//img.alicdn.com/bao/uploaded/i1/2200773126086/O1CN01MbqmJq1upR9oWGVGh_!!2200773126086-0-picasso.jpg_400x400Q50s50.jpg_.webp', 'FINNNAVIAN 伊姆斯躺椅 真皮单人沙发轻奢 Ray Eames设计师休闲椅', 8900.0, 'FINNNAVIAN旗舰店', NULL, '', 890);
INSERT INTO `goodsinfo` VALUES (17, '//img.alicdn.com/bao/uploaded/i1/3415020960/O1CN01X3GBh11IxivNnRf7I_!!3415020960-0-picasso.jpg_400x400Q50s50.jpg_.webp', '顾全单人沙发椅客厅阳台家用轻奢休闲沙发设计师极简网红懒人沙发', 1980.0, '顾全家具旗舰店', NULL, '', 230);
INSERT INTO `goodsinfo` VALUES (18, '//img.alicdn.com/bao/uploaded/i2/470164086/O1CN01YhluXH1g3R1f7Jhli_!!0-item_pic.jpg_400x400Q50s50.jpg_.webp', '维莎日式原木色实木餐桌北欧现代简约长方形橡木餐桌椅组合家具', 3860.0, '维莎旗舰店', NULL, '', 460);
INSERT INTO `goodsinfo` VALUES (19, '//img.alicdn.com/bao/uploaded/i4/2911805119/O1CN0155eLmj1ngYA6xc9AK_!!2911805119.jpg_400x400Q50s50.jpg_.webp', '全友家居单人沙发现代简约布艺沙发休闲躺椅102905', 2198.0, '全友家私家具旗舰店', NULL, '', 320);
INSERT INTO `goodsinfo` VALUES (20, '//img.alicdn.com/bao/uploaded/i3/3082296044/O1CN01GhLfXK1uWCWSmOHqu_!!3082296044.jpg_400x400Q50s50.jpg_.webp', '单人沙发轻奢现代网红真皮单椅北欧客厅设计师懒人躺椅橙色休闲椅', 1380.0, '月影家居旗舰店', NULL, '', 198);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '编号',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `tel` bigint DEFAULT NULL COMMENT '电话',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'lixin', '123', '1091547543@qq.com', 13453064163);
INSERT INTO `user` VALUES (2, 'mx12586', 'lixinshishabi', 'lxzz@mdzz.com', 13154188188);
INSERT INTO `user` VALUES (3, '1lixin', '123', '123', 123);
INSERT INTO `user` VALUES (4, 'lixin2', '123', '1qwe', 2131);
INSERT INTO `user` VALUES (7, 'qaz12138', '123', '123124@qq.com', 123);
INSERT INTO `user` VALUES (8, 'qqq', '111', '1111', 1111);
INSERT INTO `user` VALUES (9, 'asd', 'asda', '1111', 1111);
INSERT INTO `user` VALUES (10, 'lixin111', '123123', '1091547543@qq.com', 13453064163);
INSERT INTO `user` VALUES (11, 'mx12121212', '123456', '1258646984@qq.com', 13173268192);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
